package org.jeecg.modules.importExcelAnalysis.service;

import com.alibaba.fastjson.JSONArray;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.ss.util.CellRangeAddress;
import org.jeecg.common.api.vo.Result;
import org.jeecg.modules.common.utils.PoiExcelUtils;
import org.jeecg.modules.importExcelAnalysis.entity.ImportExcelAnalysis;
import com.baomidou.mybatisplus.extension.service.IService;
import org.jeecg.modules.importExcelAnalysis.vo.ImportExcelAnalysisVo;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

/**
 * @Description: import_excel_analysis
 * @author: baochangrong
 * @Date:   2022-06-21
 * @Version: V1.0
 */
public interface IImportExcelAnalysisService extends IService<ImportExcelAnalysis> {

    public List<ImportExcelAnalysis> importTarget(MultipartFile file, ImportExcelAnalysisVo importExcelAnalysisVo) throws IOException;
    public String analysisSubjectExaminationData(ImportExcelAnalysisVo importExcelAnalysisVo);
    public String analysisAchievementExamData(ImportExcelAnalysisVo importExcelAnalysisVo);
}
